Document directory
Sqlite3
Common functions
Sqlite3
SQLite is a lightweight database. Similar to common MySQL databases. Compared with MySQL, the data type is basically the same, but all SQLite commands are ". "(for example, in MySQL, check
Sqlite3 introduction and application of commonly used query statements sqlite3 database introduction SQLite database is a very lightweight self-contained (lightweightandself-contained) DBMS, Which is portable, easy to use, very small, efficient and
From: http://hi.baidu.com/vv1133/blog/item/8fae0df29f0cfc18b17ec573.html
Install
$ Tar zxvf sqlite-3.3.5.tar.gz
$ Sqlite-3.3.5 CD
$./Configure -- disable-TCL -- prefix =/usr/local/sqlite3/(the subsequent path can also be omitted, that is, it is
Python sqlite3 Database is a very small built-in module, it uses a file to store the entire database, operation is very convenient, compared to other large databases, there are some gaps. But in performance is not inferior, little, perfectly formed,
Sqlite3 each data type represents 1. Storage type and Data Type: SQLite divides the data value storage into the following Storage types: NULL: indicates that the value is NULL. INTEGER: unsigned INTEGER value. REAL: floating point value. TEXT: TEXT
Create a databaseUse sqlite3.exe in the region. The data creation command is as follows:Sqlite3 db_name.xx;The database name is arbitrary. After creation, the database is directly entered. If the file exists, the database is opened directly;
SQL
SQLite database with only one file is OK, small and convenient, so is a very good embedded database, SQLite is used in a large number of mobile phones, Pda,mp3 players and set-top box equipment.Mozilla Firefox uses SQLite as a database.Mac computers
1: Using Sqlite3 in C requires calling function interface operations: Sqlite3*db;intStatus=sqlite_open ("dbname", &db);//Open or create a database intStatus=sqlite3_exec (Db,yuju,huitiaohanshu,0, Cuowuzhizhen);//all operations of the database have
I. Introduction of SQLITE3SQLite3 is an open-source, embedded relational-type database that is portable, easy to use, and has low memory overhead.SQLite3 is untyped, which means that any type of data can be kept to any field in any table.SQLite3
SQLite database with only one file is OK, small and convenient, so is a very good embedded database, SQLite is used in a large number of mobile phones, Pda,mp3 players and set-top box equipment.Mozilla Firefox uses SQLite as a database.Mac computers
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.